# -*- coding: utf-8 -*-
'''
@author: Hugo
@file: test.py
@time: 2021/8/12 18:30
'''
import random
import openpyxl as xl


wb = xl.Workbook()
ws = wb.create_sheet('菲菲',index = 0)
ws.append(['编号','姓名','年龄'])
for i in range(20):
    id = str(i)
    name = str('ff' + str(i))
    age = random.randint(15,18)
    ws.append([id,name,age])



